Tabela StockCostLimit

Definicja tabeli StockCostLimit

Name

StockCostLimit

Code

StockCostLimit

Comment

Tabela przechowujaca definicje limitów kosztów zasobów


Lista kolumn tabeli StockCostLimit

Name

Code

StockCostLimitID

StockCostLimitID

StockLimitTypeID

StockLimitTypeID

StockID

StockID

CostAccountID

CostAccountID

StartDT

StartDT

StopDT

StopDT

CostLimit

CostLimit

Active

Active

InsertDT

InsertDT

InsertingPerson

InsertingPerson

LastModifiedDT

LastModifiedDT

LastModifiedPerson

LastModifiedPerson


Kolumna StockCostLimitID tabeli StockCostLimit

Definicja kolumny StockCostLimitID tabeli StockCostLimit

Name

StockCostLimitID

Code

StockCostLimitID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna StockLimitTypeID tabeli StockCostLimit

Definicja kolumny StockLimitTypeID tabeli StockCostLimit

Name

StockLimitTypeID

Code

StockLimitTypeID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna StockID tabeli StockCostLimit

Definicja kolumny StockID tabeli StockCostLimit

Name

StockID

Code

StockID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna CostAccountID tabeli StockCostLimit

Definicja kolumny CostAccountID tabeli StockCostLimit

Name

CostAccountID

Code

CostAccountID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna StartDT tabeli StockCostLimit

Definicja kolumny StartDT tabeli StockCostLimit

Name

StartDT

Code

StartDT

Data Type

DATE

Mandatory

No

Comment

PL: Data poczatku
EN: Start date
DE: das Beginndatum


Kolumna StopDT tabeli StockCostLimit

Definicja kolumny StopDT tabeli StockCostLimit

Name

StopDT

Code

StopDT

Data Type

DATE

Mandatory

No

Comment

PL: Data koncowa
EN: Stop date
DE: Das Endedatum


Kolumna CostLimit tabeli StockCostLimit

Definicja kolumny CostLimit tabeli StockCostLimit

Name

CostLimit

Code

CostLimit

Data Type

NUMBER(12,4)

Mandatory

No

Comment

Limit (max. wartosc zasobów)


Kolumna Active tabeli StockCostLimit

Definicja kolumny Active tabeli StockCostLimit

Name

Active

Code

Active

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna InsertDT tabeli StockCostLimit

Definicja kolumny InsertDT tabeli StockCostLimit

Name

InsertDT

Code

InsertDT

Data Type

DATE

Mandatory

No

Comment

PL: Data wstawienia rekordu
EN: Insert date of record
DE: Das Date der Ansatzstelle fur den Rekord


Kolumna InsertingPerson tabeli StockCostLimit

Definicja kolumny InsertingPerson tabeli StockCostLimit

Name

InsertingPerson

Code

InsertingPerson

Data Type

NUMBER(10)

Mandatory

No

Comment

PL: Osoba wstawiajaca rekord
EN: Person inserting record


Kolumna LastModifiedDT tabeli StockCostLimit

Definicja kolumny LastModifiedDT tabeli StockCostLimit

Name

LastModifiedDT

Code

LastModifiedDT

Data Type

DATE

Mandatory

No

Comment

Data ostatniej modyfikacji


Kolumna LastModifiedPerson tabeli StockCostLimit

Definicja kolumny LastModifiedPerson tabeli StockCostLimit

Name

LastModifiedPerson

Code

LastModifiedPerson

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Lista kluczy tabeli StockCostLimit

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli StockCostLimit

Definicja klucza Identifier_1 tabeli StockCostLimit

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment